Lecture-1: Introduction to Databases

Updated: August 8, 2025

Lecture-2: Introduction to Database, Database users, characteristics and advantages of the database, Database systems, Concepts and architecture-Data models

Updated: August 12, 2025

Lecture-3: Schemas, Instances & States, Three-Schema Architecture, and Data Independence.

Updated: August 18, 2025

Lecture-4: DBMS Languages & Interfaces - DDL, DML, DCL, TCL, High-Level vs Low-Level Languages, DBMS Interfaces, System Utilities, and Component Modules

Updated: August 22, 2025

Lecture-5: Integrity Constraints in DBMS

Understanding and implementing domain, key, entity, and referential integrity constraints in database systems

Updated: September 4, 2025

Lecture-6: EER Diagram & Reduction to Tables

Understanding Extended Entity-Relationship (EER) modeling, specialization, generalization, and converting EER diagrams to relational tables

Updated: September 7, 2025

Lecture-7: Relational Algebra & Relational Calculus

Comprehensive coverage of relational algebra operations and relational calculus for database querying, including set operations, joins, and division

Updated: September 8, 2025

Lecture-8: Database Anomalies and Dependencies

Understanding and resolving database anomalies through functional, multivalued, and join dependencies, and their role in database normalization

Updated: September 9, 2025

Lecture-9: Normal Forms & Limitations of Relational Data Model

Understand Normalization and Limitations of Relational Data Model

Updated: September 9, 2025

Lecture-10: Introduction to Transactions

Understanding transaction concepts, ACID properties, transaction states, and concurrency control in database systems

Updated: September 26, 2025

Lecture-11: Concurrency Control Protocols & Deadlocks

Exploring concurrency control mechanisms, two-phase locking, timestamp ordering, and deadlock handling in database systems

Updated: October 1, 2025

Lecture-12: Query Optimization

Understanding query processing, cost-based optimization, and query execution plans in database systems

Updated: October 3, 2025

Lecture-13: File Organization and Indexing

Understanding file organization techniques (heap, sequential, hash), indexing concepts, primary indexes, and performance analysis with practical calculations

Updated: October 14, 2025

Lecture-14: Clustering and Secondary Indexing

Deep dive into clustering indexes, secondary indexes, dense vs sparse indexing, with practical examples and performance calculations

Updated: October 16, 2025

Lectures coming soon

Lectures coming soon

Lectures coming soon

Lab 1: University Database ER Diagram

Design and Implementation of University Database System - ER diagram specifications, SQL schema, and database model

Updated: August 17, 2025

Lab 2: Company Database ER Diagram

Design Assignment - Create ER diagram for company database with employees, departments, projects, and relationships

Updated: August 17, 2025

Lab 3: DDL and DML Commands with Key Constraints

Hands-on practice with SQL DDL and DML commands, implementing database constraints (Primary Key, Foreign Key, UNIQUE, CHECK), and testing referential integrity

Updated: September 1, 2025

Lab 4: SQL Constraints Implementation

Understanding and applying SQL constraints including Primary Key, Foreign Key, and other integrity constraints with practical exercises

Updated: September 7, 2025

Lab 5: To understand and use SQL Sub-Query

Objective: To understand the use of SQL subquery and implement various subquery operations on relational database tables.

Updated: September 7, 2025

Lab 6: Use of Inbuilt Functions and Relational Algebra Operations

Objective: To understand the use of inbuilt functions and relational algebra operations with SQL queries using the COMPANY database schema.

Updated: September 22, 2025